package ai.people.platform.jx.mapper;

import ai.people.netmon.framework.domain.common.NameValueEntity;
import ai.people.netmon.framework.domain.jx.AccountPosition;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author LiGuanNan
 * @date 2022/6/30 13:54
 */
@Mapper
public interface AccountPositionMapper extends BaseMapper<AccountPosition> {

    @Select("select city as name, count(0) as value from telegram.v_located_users GROUP BY city")
    List<NameValueEntity<String,Long>> cityOverView();
}
